﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Customers_and_OrdersDataSet" targetNamespace="http://tempuri.org/Customers_and_OrdersDataSet.xsd" xmlns:mstns="http://tempuri.org/Customers_and_OrdersDataSet.xsd" xmlns="http://tempuri.org/Customers_and_OrdersDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="Customers_and_OrdersConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Customers_and_OrdersConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings._23._05.My.MySettings.GlobalReference.Default.Customers_and_OrdersConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AddressesTableAdapter" GeneratorDataComponentClassName="AddressesTableAdapter" Name="Addresses" UserDataComponentName="AddressesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Addresses" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Addresses] WHERE (([address_id] = @Original_address_id) AND ((@IsNull_line_1 = 1 AND [line_1] IS NULL) OR ([line_1] = @Original_line_1)) AND ((@IsNull_line_2 = 1 AND [line_2] IS NULL) OR ([line_2] = @Original_line_2)) AND ((@IsNull_line_3 = 1 AND [line_3] IS NULL) OR ([line_3] = @Original_line_3)) AND ((@IsNull_city = 1 AND [city] IS NULL) OR ([city] = @Original_city)) AND ((@IsNull_zip_postcode = 1 AND [zip_postcode] IS NULL) OR ([zip_postcode] = @Original_zip_postcode)) AND ((@IsNull_state_province_county = 1 AND [state_province_county] IS NULL) OR ([state_province_county] = @Original_state_province_county)) AND ((@IsNull_iso_country_code = 1 AND [iso_country_code] IS NULL) OR ([iso_country_code] = @Original_iso_country_code)) AND ((@IsNull_other_address_details = 1 AND [other_address_details] IS NULL) OR ([other_address_details] = @Original_other_address_details)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_address_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_line_1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="line_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_line_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_line_2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="line_2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_line_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_line_3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="line_3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_line_3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_city" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zip_postcode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zip_postcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_zip_postcode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="zip_postcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_state_province_county" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="state_province_county" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_state_province_county" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="state_province_county" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iso_country_code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iso_country_code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_iso_country_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="iso_country_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_address_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_address_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_address_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_address_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Addresses] ([line_1], [line_2], [line_3], [city], [zip_postcode], [state_province_county], [iso_country_code], [other_address_details]) VALUES (@line_1, @line_2, @line_3, @city, @zip_postcode, @state_province_county, @iso_country_code, @other_address_details);
SELECT address_id, line_1, line_2, line_3, city, zip_postcode, state_province_county, iso_country_code, other_address_details FROM Addresses WHERE (address_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@line_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@line_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@line_3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@zip_postcode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="zip_postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@state_province_county" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="state_province_county" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@iso_country_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="iso_country_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_address_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_address_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT address_id, line_1, line_2, line_3, city, zip_postcode, state_province_county, iso_country_code, other_address_details FROM dbo.Addresses</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Addresses] SET [line_1] = @line_1, [line_2] = @line_2, [line_3] = @line_3, [city] = @city, [zip_postcode] = @zip_postcode, [state_province_county] = @state_province_county, [iso_country_code] = @iso_country_code, [other_address_details] = @other_address_details WHERE (([address_id] = @Original_address_id) AND ((@IsNull_line_1 = 1 AND [line_1] IS NULL) OR ([line_1] = @Original_line_1)) AND ((@IsNull_line_2 = 1 AND [line_2] IS NULL) OR ([line_2] = @Original_line_2)) AND ((@IsNull_line_3 = 1 AND [line_3] IS NULL) OR ([line_3] = @Original_line_3)) AND ((@IsNull_city = 1 AND [city] IS NULL) OR ([city] = @Original_city)) AND ((@IsNull_zip_postcode = 1 AND [zip_postcode] IS NULL) OR ([zip_postcode] = @Original_zip_postcode)) AND ((@IsNull_state_province_county = 1 AND [state_province_county] IS NULL) OR ([state_province_county] = @Original_state_province_county)) AND ((@IsNull_iso_country_code = 1 AND [iso_country_code] IS NULL) OR ([iso_country_code] = @Original_iso_country_code)) AND ((@IsNull_other_address_details = 1 AND [other_address_details] IS NULL) OR ([other_address_details] = @Original_other_address_details)));
SELECT address_id, line_1, line_2, line_3, city, zip_postcode, state_province_county, iso_country_code, other_address_details FROM Addresses WHERE (address_id = @address_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@line_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@line_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@line_3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@zip_postcode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="zip_postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@state_province_county" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="state_province_county" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@iso_country_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="iso_country_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_address_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_address_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_address_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_line_1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="line_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_line_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_line_2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="line_2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_line_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_line_3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="line_3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_line_3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="line_3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_city" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zip_postcode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zip_postcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_zip_postcode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="zip_postcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_state_province_county" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="state_province_county" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_state_province_county" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="state_province_county" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iso_country_code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iso_country_code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_iso_country_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="iso_country_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_address_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_address_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_address_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_address_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="address_id" ColumnName="address_id" DataSourceName="[Y:\LIBRI\07_LIBRO_VB2010\ESEMPI\VB2010\CAP23\23.05\CUSTOMERS_AND_ORDERS.MDF].dbo.Addresses" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@address_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="address_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="address_id" DataSetColumn="address_id" />
              <Mapping SourceColumn="line_1" DataSetColumn="line_1" />
              <Mapping SourceColumn="line_2" DataSetColumn="line_2" />
              <Mapping SourceColumn="line_3" DataSetColumn="line_3" />
              <Mapping SourceColumn="city" DataSetColumn="city" />
              <Mapping SourceColumn="zip_postcode" DataSetColumn="zip_postcode" />
              <Mapping SourceColumn="state_province_county" DataSetColumn="state_province_county" />
              <Mapping SourceColumn="iso_country_code" DataSetColumn="iso_country_code" />
              <Mapping SourceColumn="other_address_details" DataSetColumn="other_address_details" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Customer_AddressesTableAdapter" GeneratorDataComponentClassName="Customer_AddressesTableAdapter" Name="Customer_Addresses" UserDataComponentName="Customer_AddressesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Customer_Addresses" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Customer_Addresses] WHERE (([customer_id] = @Original_customer_id) AND ([address_id] = @Original_address_id) AND ([date_from] = @Original_date_from) AND ([address_type_code] = @Original_address_type_code) AND ((@IsNull_date_to = 1 AND [date_to] IS NULL) OR ([date_to] = @Original_date_to)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_address_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_from" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_address_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="address_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_to" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_to" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Customer_Addresses] ([customer_id], [address_id], [date_from], [address_type_code], [date_to]) VALUES (@customer_id, @address_id, @date_from, @address_type_code, @date_to);
SELECT customer_id, address_id, date_from, address_type_code, date_to FROM Customer_Addresses WHERE (address_id = @address_id) AND (customer_id = @customer_id) AND (date_from = @date_from)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@address_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_from" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@address_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="address_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_to" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT customer_id, address_id, date_from, address_type_code, date_to FROM dbo.Customer_Addresses</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Customer_Addresses] SET [customer_id] = @customer_id, [address_id] = @address_id, [date_from] = @date_from, [address_type_code] = @address_type_code, [date_to] = @date_to WHERE (([customer_id] = @Original_customer_id) AND ([address_id] = @Original_address_id) AND ([date_from] = @Original_date_from) AND ([address_type_code] = @Original_address_type_code) AND ((@IsNull_date_to = 1 AND [date_to] IS NULL) OR ([date_to] = @Original_date_to)));
SELECT customer_id, address_id, date_from, address_type_code, date_to FROM Customer_Addresses WHERE (address_id = @address_id) AND (customer_id = @customer_id) AND (date_from = @date_from)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@address_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_from" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@address_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="address_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_to" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_address_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_from" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_address_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="address_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_to" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_to" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="customer_id" DataSetColumn="customer_id" />
              <Mapping SourceColumn="address_id" DataSetColumn="address_id" />
              <Mapping SourceColumn="date_from" DataSetColumn="date_from" />
              <Mapping SourceColumn="address_type_code" DataSetColumn="address_type_code" />
              <Mapping SourceColumn="date_to" DataSetColumn="date_to" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Customer_OrdersTableAdapter" GeneratorDataComponentClassName="Customer_OrdersTableAdapter" Name="Customer_Orders" UserDataComponentName="Customer_OrdersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Customer_Orders" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Customer_Orders] WHERE (([order_id] = @Original_order_id) AND ([customer_id] = @Original_customer_id) AND ([customer_payment_method_id] = @Original_customer_payment_method_id) AND ([order_status_code] = @Original_order_status_code) AND ([date_order_placed] = @Original_date_order_placed) AND ((@IsNull_date_order_paid = 1 AND [date_order_paid] IS NULL) OR ([date_order_paid] = @Original_date_order_paid)) AND ((@IsNull_der_total_order_price = 1 AND [der_total_order_price] IS NULL) OR ([der_total_order_price] = @Original_der_total_order_price)) AND ((@IsNull_other_order_details = 1 AND [other_order_details] IS NULL) OR ([other_order_details] = @Original_other_order_details)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_payment_method_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_payment_method_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_order_status_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="order_status_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_order_placed" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_order_placed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_order_paid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_order_paid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_order_paid" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_order_paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_der_total_order_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="der_total_order_price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_der_total_order_price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="der_total_order_price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_order_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_order_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_order_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_order_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Customer_Orders] ([customer_id], [customer_payment_method_id], [order_status_code], [date_order_placed], [date_order_paid], [der_total_order_price], [other_order_details]) VALUES (@customer_id, @customer_payment_method_id, @order_status_code, @date_order_placed, @date_order_paid, @der_total_order_price, @other_order_details);
SELECT order_id, customer_id, customer_payment_method_id, order_status_code, date_order_placed, date_order_paid, der_total_order_price, other_order_details FROM Customer_Orders WHERE (order_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@customer_payment_method_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_payment_method_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@order_status_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="order_status_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_order_placed" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_order_placed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_order_paid" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_order_paid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@der_total_order_price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="der_total_order_price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_order_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_order_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT order_id, customer_id, customer_payment_method_id, order_status_code, date_order_placed, date_order_paid, der_total_order_price, other_order_details FROM dbo.Customer_Orders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Customer_Orders] SET [customer_id] = @customer_id, [customer_payment_method_id] = @customer_payment_method_id, [order_status_code] = @order_status_code, [date_order_placed] = @date_order_placed, [date_order_paid] = @date_order_paid, [der_total_order_price] = @der_total_order_price, [other_order_details] = @other_order_details WHERE (([order_id] = @Original_order_id) AND ([customer_id] = @Original_customer_id) AND ([customer_payment_method_id] = @Original_customer_payment_method_id) AND ([order_status_code] = @Original_order_status_code) AND ([date_order_placed] = @Original_date_order_placed) AND ((@IsNull_date_order_paid = 1 AND [date_order_paid] IS NULL) OR ([date_order_paid] = @Original_date_order_paid)) AND ((@IsNull_der_total_order_price = 1 AND [der_total_order_price] IS NULL) OR ([der_total_order_price] = @Original_der_total_order_price)) AND ((@IsNull_other_order_details = 1 AND [other_order_details] IS NULL) OR ([other_order_details] = @Original_other_order_details)));
SELECT order_id, customer_id, customer_payment_method_id, order_status_code, date_order_placed, date_order_paid, der_total_order_price, other_order_details FROM Customer_Orders WHERE (order_id = @order_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@customer_payment_method_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_payment_method_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@order_status_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="order_status_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_order_placed" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_order_placed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_order_paid" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_order_paid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@der_total_order_price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="der_total_order_price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_order_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_order_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_payment_method_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_payment_method_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_order_status_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="order_status_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_order_placed" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_order_placed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_order_paid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_order_paid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_order_paid" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_order_paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_der_total_order_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="der_total_order_price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_der_total_order_price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="der_total_order_price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_order_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_order_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_order_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_order_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="order_id" ColumnName="order_id" DataSourceName="[Y:\LIBRI\07_LIBRO_VB2010\ESEMPI\VB2010\CAP23\23.05\CUSTOMERS_AND_ORDERS.MDF].dbo.Customer_Orders" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@order_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="order_id" DataSetColumn="order_id" />
              <Mapping SourceColumn="customer_id" DataSetColumn="customer_id" />
              <Mapping SourceColumn="customer_payment_method_id" DataSetColumn="customer_payment_method_id" />
              <Mapping SourceColumn="order_status_code" DataSetColumn="order_status_code" />
              <Mapping SourceColumn="date_order_placed" DataSetColumn="date_order_placed" />
              <Mapping SourceColumn="date_order_paid" DataSetColumn="date_order_paid" />
              <Mapping SourceColumn="der_total_order_price" DataSetColumn="der_total_order_price" />
              <Mapping SourceColumn="other_order_details" DataSetColumn="other_order_details" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Customer_Orders_DeliveryTableAdapter" GeneratorDataComponentClassName="Customer_Orders_DeliveryTableAdapter" Name="Customer_Orders_Delivery" UserDataComponentName="Customer_Orders_DeliveryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Customer_Orders_Delivery" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Customer_Orders_Delivery] WHERE (([order_id] = @Original_order_id) AND ([date_reported] = @Original_date_reported) AND ([delivery_status_code] = @Original_delivery_status_code))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_reported" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_reported" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_delivery_status_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Customer_Orders_Delivery] ([order_id], [date_reported], [delivery_status_code]) VALUES (@order_id, @date_reported, @delivery_status_code);
SELECT order_id, date_reported, delivery_status_code FROM Customer_Orders_Delivery WHERE (date_reported = @date_reported) AND (order_id = @order_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_reported" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_reported" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@delivery_status_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT order_id, date_reported, delivery_status_code FROM dbo.Customer_Orders_Delivery</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Customer_Orders_Delivery] SET [order_id] = @order_id, [date_reported] = @date_reported, [delivery_status_code] = @delivery_status_code WHERE (([order_id] = @Original_order_id) AND ([date_reported] = @Original_date_reported) AND ([delivery_status_code] = @Original_delivery_status_code));
SELECT order_id, date_reported, delivery_status_code FROM Customer_Orders_Delivery WHERE (date_reported = @date_reported) AND (order_id = @order_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_reported" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_reported" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@delivery_status_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_reported" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_reported" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_delivery_status_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="order_id" DataSetColumn="order_id" />
              <Mapping SourceColumn="date_reported" DataSetColumn="date_reported" />
              <Mapping SourceColumn="delivery_status_code" DataSetColumn="delivery_status_code" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Customer_Orders_ProductsTableAdapter" GeneratorDataComponentClassName="Customer_Orders_ProductsTableAdapter" Name="Customer_Orders_Products" UserDataComponentName="Customer_Orders_ProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Customer_Orders_Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Customer_Orders_Products] WHERE (([order_id] = @Original_order_id) AND ([product_id] = @Original_product_id) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_comments = 1 AND [comments] IS NULL) OR ([comments] = @Original_comments)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_product_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_quantity" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_comments" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comments" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_comments" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="comments" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Customer_Orders_Products] ([order_id], [product_id], [quantity], [comments]) VALUES (@order_id, @product_id, @quantity, @comments);
SELECT order_id, product_id, quantity, comments FROM Customer_Orders_Products WHERE (order_id = @order_id) AND (product_id = @product_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@product_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@quantity" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@comments" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="comments" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT order_id, product_id, quantity, comments FROM dbo.Customer_Orders_Products</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Customer_Orders_Products] SET [order_id] = @order_id, [product_id] = @product_id, [quantity] = @quantity, [comments] = @comments WHERE (([order_id] = @Original_order_id) AND ([product_id] = @Original_product_id) AND ((@IsNull_quantity = 1 AND [quantity] IS NULL) OR ([quantity] = @Original_quantity)) AND ((@IsNull_comments = 1 AND [comments] IS NULL) OR ([comments] = @Original_comments)));
SELECT order_id, product_id, quantity, comments FROM Customer_Orders_Products WHERE (order_id = @order_id) AND (product_id = @product_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@product_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@quantity" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@comments" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="comments" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_order_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_product_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_quantity" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_comments" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comments" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_comments" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="comments" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="order_id" DataSetColumn="order_id" />
              <Mapping SourceColumn="product_id" DataSetColumn="product_id" />
              <Mapping SourceColumn="quantity" DataSetColumn="quantity" />
              <Mapping SourceColumn="comments" DataSetColumn="comments" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomersTableAdapter" GeneratorDataComponentClassName="CustomersTableAdapter" Name="Customers" UserDataComponentName="CustomersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Customers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Customers] WHERE (([customer_id] = @Original_customer_id) AND ((@IsNull_first_name = 1 AND [first_name] IS NULL) OR ([first_name] = @Original_first_name)) AND ((@IsNull_middle_name = 1 AND [middle_name] IS NULL) OR ([middle_name] = @Original_middle_name)) AND ((@IsNull_last_name = 1 AND [last_name] IS NULL) OR ([last_name] = @Original_last_name)) AND ((@IsNull_customer_phone = 1 AND [customer_phone] IS NULL) OR ([customer_phone] = @Original_customer_phone)) AND ((@IsNull_customer_email = 1 AND [customer_email] IS NULL) OR ([customer_email] = @Original_customer_email)) AND ((@IsNull_other_customer_details = 1 AND [other_customer_details] IS NULL) OR ([other_customer_details] = @Original_other_customer_details)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_first_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="first_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_first_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="first_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_middle_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_last_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="last_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_last_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="last_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_customer_phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_customer_phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="customer_phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_customer_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_customer_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="customer_email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_customer_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_customer_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_customer_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_customer_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Customers] ([first_name], [middle_name], [last_name], [customer_phone], [customer_email], [other_customer_details]) VALUES (@first_name, @middle_name, @last_name, @customer_phone, @customer_email, @other_customer_details);
SELECT customer_id, first_name, middle_name, last_name, customer_phone, customer_email, other_customer_details FROM Customers WHERE (customer_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@first_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="first_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@last_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="last_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@customer_phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="customer_phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@customer_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="customer_email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_customer_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_customer_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT customer_id, first_name, middle_name, last_name, customer_phone, customer_email, other_customer_details FROM dbo.Customers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Customers] SET [first_name] = @first_name, [middle_name] = @middle_name, [last_name] = @last_name, [customer_phone] = @customer_phone, [customer_email] = @customer_email, [other_customer_details] = @other_customer_details WHERE (([customer_id] = @Original_customer_id) AND ((@IsNull_first_name = 1 AND [first_name] IS NULL) OR ([first_name] = @Original_first_name)) AND ((@IsNull_middle_name = 1 AND [middle_name] IS NULL) OR ([middle_name] = @Original_middle_name)) AND ((@IsNull_last_name = 1 AND [last_name] IS NULL) OR ([last_name] = @Original_last_name)) AND ((@IsNull_customer_phone = 1 AND [customer_phone] IS NULL) OR ([customer_phone] = @Original_customer_phone)) AND ((@IsNull_customer_email = 1 AND [customer_email] IS NULL) OR ([customer_email] = @Original_customer_email)) AND ((@IsNull_other_customer_details = 1 AND [other_customer_details] IS NULL) OR ([other_customer_details] = @Original_other_customer_details)));
SELECT customer_id, first_name, middle_name, last_name, customer_phone, customer_email, other_customer_details FROM Customers WHERE (customer_id = @customer_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@first_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="first_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@last_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="last_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@customer_phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="customer_phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@customer_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="customer_email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_customer_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_customer_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_first_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="first_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_first_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="first_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_middle_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_last_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="last_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_last_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="last_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_customer_phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_customer_phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="customer_phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_customer_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_customer_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="customer_email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_customer_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_customer_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_customer_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_customer_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="customer_id" ColumnName="customer_id" DataSourceName="[Y:\LIBRI\07_LIBRO_VB2010\ESEMPI\VB2010\CAP23\23.05\CUSTOMERS_AND_ORDERS.MDF].dbo.Customers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@customer_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="customer_id" DataSetColumn="customer_id" />
              <Mapping SourceColumn="first_name" DataSetColumn="first_name" />
              <Mapping SourceColumn="middle_name" DataSetColumn="middle_name" />
              <Mapping SourceColumn="last_name" DataSetColumn="last_name" />
              <Mapping SourceColumn="customer_phone" DataSetColumn="customer_phone" />
              <Mapping SourceColumn="customer_email" DataSetColumn="customer_email" />
              <Mapping SourceColumn="other_customer_details" DataSetColumn="other_customer_details" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Customers_Payment_MethodsTableAdapter" GeneratorDataComponentClassName="Customers_Payment_MethodsTableAdapter" Name="Customers_Payment_Methods" UserDataComponentName="Customers_Payment_MethodsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Customers_Payment_Methods" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Customers_Payment_Methods] WHERE (([customer_payment_method_id] = @Original_customer_payment_method_id) AND ([customer_id] = @Original_customer_id) AND ([payment_method_code] = @Original_payment_method_code) AND ((@IsNull_card_number = 1 AND [card_number] IS NULL) OR ([card_number] = @Original_card_number)) AND ((@IsNull_date_from = 1 AND [date_from] IS NULL) OR ([date_from] = @Original_date_from)) AND ((@IsNull_date_to = 1 AND [date_to] IS NULL) OR ([date_to] = @Original_date_to)) AND ((@IsNull_other_details = 1 AND [other_details] IS NULL) OR ([other_details] = @Original_other_details)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_payment_method_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_payment_method_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_payment_method_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="payment_method_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_card_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="card_number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_card_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="card_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_from" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_from" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_to" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_to" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Customers_Payment_Methods] ([customer_id], [payment_method_code], [card_number], [date_from], [date_to], [other_details]) VALUES (@customer_id, @payment_method_code, @card_number, @date_from, @date_to, @other_details);
SELECT customer_payment_method_id, customer_id, payment_method_code, card_number, date_from, date_to, other_details FROM Customers_Payment_Methods WHERE (customer_payment_method_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@payment_method_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="payment_method_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@card_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="card_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_from" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_to" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT customer_payment_method_id, customer_id, payment_method_code, card_number, date_from, date_to, other_details FROM dbo.Customers_Payment_Methods</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Customers_Payment_Methods] SET [customer_id] = @customer_id, [payment_method_code] = @payment_method_code, [card_number] = @card_number, [date_from] = @date_from, [date_to] = @date_to, [other_details] = @other_details WHERE (([customer_payment_method_id] = @Original_customer_payment_method_id) AND ([customer_id] = @Original_customer_id) AND ([payment_method_code] = @Original_payment_method_code) AND ((@IsNull_card_number = 1 AND [card_number] IS NULL) OR ([card_number] = @Original_card_number)) AND ((@IsNull_date_from = 1 AND [date_from] IS NULL) OR ([date_from] = @Original_date_from)) AND ((@IsNull_date_to = 1 AND [date_to] IS NULL) OR ([date_to] = @Original_date_to)) AND ((@IsNull_other_details = 1 AND [other_details] IS NULL) OR ([other_details] = @Original_other_details)));
SELECT customer_payment_method_id, customer_id, payment_method_code, card_number, date_from, date_to, other_details FROM Customers_Payment_Methods WHERE (customer_payment_method_id = @customer_payment_method_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@payment_method_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="payment_method_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@card_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="card_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_from" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_to" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_payment_method_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_payment_method_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_customer_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="customer_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_payment_method_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="payment_method_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_card_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="card_number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_card_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="card_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_from" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_from" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_to" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_to" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_to" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="customer_payment_method_id" ColumnName="customer_payment_method_id" DataSourceName="[Y:\LIBRI\07_LIBRO_VB2010\ESEMPI\VB2010\CAP23\23.05\CUSTOMERS_AND_ORDERS.MDF].dbo.Customers_Payment_Methods" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@customer_payment_method_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="customer_payment_method_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="customer_payment_method_id" DataSetColumn="customer_payment_method_id" />
              <Mapping SourceColumn="customer_id" DataSetColumn="customer_id" />
              <Mapping SourceColumn="payment_method_code" DataSetColumn="payment_method_code" />
              <Mapping SourceColumn="card_number" DataSetColumn="card_number" />
              <Mapping SourceColumn="date_from" DataSetColumn="date_from" />
              <Mapping SourceColumn="date_to" DataSetColumn="date_to" />
              <Mapping SourceColumn="other_details" DataSetColumn="other_details" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Products] WHERE (([product_id] = @Original_product_id) AND ([product_type_code] = @Original_product_type_code) AND ([supplier_code] = @Original_supplier_code) AND ((@IsNull_product_price = 1 AND [product_price] IS NULL) OR ([product_price] = @Original_product_price)) AND ((@IsNull_book_isbn = 1 AND [book_isbn] IS NULL) OR ([book_isbn] = @Original_book_isbn)) AND ((@IsNull_book_author = 1 AND [book_author] IS NULL) OR ([book_author] = @Original_book_author)) AND ((@IsNull_book_publication_date = 1 AND [book_publication_date] IS NULL) OR ([book_publication_date] = @Original_book_publication_date)) AND ((@IsNull_book_title = 1 AND [book_title] IS NULL) OR ([book_title] = @Original_book_title)) AND ((@IsNull_book_price = 1 AND [book_price] IS NULL) OR ([book_price] = @Original_book_price)) AND ((@IsNull_food_contains_yn = 1 AND [food_contains_yn] IS NULL) OR ([food_contains_yn] = @Original_food_contains_yn)) AND ((@IsNull_food_name = 1 AND [food_name] IS NULL) OR ([food_name] = @Original_food_name)) AND ((@IsNull_food_description = 1 AND [food_description] IS NULL) OR ([food_description] = @Original_food_description)) AND ((@IsNull_food_flavor = 1 AND [food_flavor] IS NULL) OR ([food_flavor] = @Original_food_flavor)) AND ((@IsNull_food_ingredients = 1 AND [food_ingredients] IS NULL) OR ([food_ingredients] = @Original_food_ingredients)) AND ((@IsNull_other_product_details = 1 AND [other_product_details] IS NULL) OR ([other_product_details] = @Original_other_product_details)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_product_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="product_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_supplier_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_product_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_product_price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="product_price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_isbn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_isbn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_book_isbn" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="book_isbn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_author" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_author" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_book_author" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="book_author" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_publication_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_publication_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_book_publication_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="book_publication_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_book_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="book_title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_book_price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="book_price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_contains_yn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_contains_yn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_food_contains_yn" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="food_contains_yn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_food_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_food_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_flavor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_flavor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_food_flavor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_flavor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_ingredients" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_ingredients" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_food_ingredients" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_ingredients" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_product_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_product_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_product_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_product_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Products] ([product_type_code], [supplier_code], [product_price], [book_isbn], [book_author], [book_publication_date], [book_title], [book_price], [food_contains_yn], [food_name], [food_description], [food_flavor], [food_ingredients], [other_product_details]) VALUES (@product_type_code, @supplier_code, @product_price, @book_isbn, @book_author, @book_publication_date, @book_title, @book_price, @food_contains_yn, @food_name, @food_description, @food_flavor, @food_ingredients, @other_product_details);
SELECT product_id, product_type_code, supplier_code, product_price, book_isbn, book_author, book_publication_date, book_title, book_price, food_contains_yn, food_name, food_description, food_flavor, food_ingredients, other_product_details FROM Products WHERE (product_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="product_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@supplier_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@product_price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="product_price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@book_isbn" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="book_isbn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@book_author" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="book_author" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@book_publication_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="book_publication_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@book_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="book_title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@book_price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="book_price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@food_contains_yn" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="food_contains_yn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@food_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@food_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@food_flavor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_flavor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@food_ingredients" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_ingredients" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_product_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_product_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT product_id, product_type_code, supplier_code, product_price, book_isbn, book_author, book_publication_date, book_title, book_price, food_contains_yn, food_name, food_description, food_flavor, food_ingredients, other_product_details FROM dbo.Products</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Products] SET [product_type_code] = @product_type_code, [supplier_code] = @supplier_code, [product_price] = @product_price, [book_isbn] = @book_isbn, [book_author] = @book_author, [book_publication_date] = @book_publication_date, [book_title] = @book_title, [book_price] = @book_price, [food_contains_yn] = @food_contains_yn, [food_name] = @food_name, [food_description] = @food_description, [food_flavor] = @food_flavor, [food_ingredients] = @food_ingredients, [other_product_details] = @other_product_details WHERE (([product_id] = @Original_product_id) AND ([product_type_code] = @Original_product_type_code) AND ([supplier_code] = @Original_supplier_code) AND ((@IsNull_product_price = 1 AND [product_price] IS NULL) OR ([product_price] = @Original_product_price)) AND ((@IsNull_book_isbn = 1 AND [book_isbn] IS NULL) OR ([book_isbn] = @Original_book_isbn)) AND ((@IsNull_book_author = 1 AND [book_author] IS NULL) OR ([book_author] = @Original_book_author)) AND ((@IsNull_book_publication_date = 1 AND [book_publication_date] IS NULL) OR ([book_publication_date] = @Original_book_publication_date)) AND ((@IsNull_book_title = 1 AND [book_title] IS NULL) OR ([book_title] = @Original_book_title)) AND ((@IsNull_book_price = 1 AND [book_price] IS NULL) OR ([book_price] = @Original_book_price)) AND ((@IsNull_food_contains_yn = 1 AND [food_contains_yn] IS NULL) OR ([food_contains_yn] = @Original_food_contains_yn)) AND ((@IsNull_food_name = 1 AND [food_name] IS NULL) OR ([food_name] = @Original_food_name)) AND ((@IsNull_food_description = 1 AND [food_description] IS NULL) OR ([food_description] = @Original_food_description)) AND ((@IsNull_food_flavor = 1 AND [food_flavor] IS NULL) OR ([food_flavor] = @Original_food_flavor)) AND ((@IsNull_food_ingredients = 1 AND [food_ingredients] IS NULL) OR ([food_ingredients] = @Original_food_ingredients)) AND ((@IsNull_other_product_details = 1 AND [other_product_details] IS NULL) OR ([other_product_details] = @Original_other_product_details)));
SELECT product_id, product_type_code, supplier_code, product_price, book_isbn, book_author, book_publication_date, book_title, book_price, food_contains_yn, food_name, food_description, food_flavor, food_ingredients, other_product_details FROM Products WHERE (product_id = @product_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="product_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@supplier_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@product_price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="product_price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@book_isbn" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="book_isbn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@book_author" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="book_author" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@book_publication_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="book_publication_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@book_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="book_title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@book_price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="book_price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@food_contains_yn" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="food_contains_yn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@food_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@food_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@food_flavor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_flavor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@food_ingredients" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_ingredients" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_product_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_product_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_product_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="product_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_supplier_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_product_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_product_price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="product_price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_isbn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_isbn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_book_isbn" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="book_isbn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_author" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_author" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_book_author" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="book_author" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_publication_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_publication_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_book_publication_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="book_publication_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_book_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="book_title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_book_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_book_price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="book_price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_contains_yn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_contains_yn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_food_contains_yn" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="food_contains_yn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_food_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_food_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_flavor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_flavor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_food_flavor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_flavor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_food_ingredients" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="food_ingredients" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_food_ingredients" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="food_ingredients" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_product_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_product_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_product_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_product_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="product_id" ColumnName="product_id" DataSourceName="[Y:\LIBRI\07_LIBRO_VB2010\ESEMPI\VB2010\CAP23\23.05\CUSTOMERS_AND_ORDERS.MDF].dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@product_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="product_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="product_id" DataSetColumn="product_id" />
              <Mapping SourceColumn="product_type_code" DataSetColumn="product_type_code" />
              <Mapping SourceColumn="supplier_code" DataSetColumn="supplier_code" />
              <Mapping SourceColumn="product_price" DataSetColumn="product_price" />
              <Mapping SourceColumn="book_isbn" DataSetColumn="book_isbn" />
              <Mapping SourceColumn="book_author" DataSetColumn="book_author" />
              <Mapping SourceColumn="book_publication_date" DataSetColumn="book_publication_date" />
              <Mapping SourceColumn="book_title" DataSetColumn="book_title" />
              <Mapping SourceColumn="book_price" DataSetColumn="book_price" />
              <Mapping SourceColumn="food_contains_yn" DataSetColumn="food_contains_yn" />
              <Mapping SourceColumn="food_name" DataSetColumn="food_name" />
              <Mapping SourceColumn="food_description" DataSetColumn="food_description" />
              <Mapping SourceColumn="food_flavor" DataSetColumn="food_flavor" />
              <Mapping SourceColumn="food_ingredients" DataSetColumn="food_ingredients" />
              <Mapping SourceColumn="other_product_details" DataSetColumn="other_product_details" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Ref_Address_TypesTableAdapter" GeneratorDataComponentClassName="Ref_Address_TypesTableAdapter" Name="Ref_Address_Types" UserDataComponentName="Ref_Address_TypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Ref_Address_Types" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Ref_Address_Types] WHERE (([address_type_code] = @Original_address_type_code) AND ((@IsNull_address_type_description = 1 AND [address_type_description] IS NULL) OR ([address_type_description] = @Original_address_type_description)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_address_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="address_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_address_type_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address_type_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_address_type_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address_type_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Ref_Address_Types] ([address_type_code], [address_type_description]) VALUES (@address_type_code, @address_type_description);
SELECT address_type_code, address_type_description FROM Ref_Address_Types WHERE (address_type_code = @address_type_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@address_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="address_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address_type_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address_type_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT address_type_code, address_type_description FROM dbo.Ref_Address_Types</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Ref_Address_Types] SET [address_type_code] = @address_type_code, [address_type_description] = @address_type_description WHERE (([address_type_code] = @Original_address_type_code) AND ((@IsNull_address_type_description = 1 AND [address_type_description] IS NULL) OR ([address_type_description] = @Original_address_type_description)));
SELECT address_type_code, address_type_description FROM Ref_Address_Types WHERE (address_type_code = @address_type_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@address_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="address_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address_type_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address_type_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_address_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="address_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_address_type_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address_type_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_address_type_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address_type_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="address_type_code" DataSetColumn="address_type_code" />
              <Mapping SourceColumn="address_type_description" DataSetColumn="address_type_description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Ref_Delivery_Status_CodesTableAdapter" GeneratorDataComponentClassName="Ref_Delivery_Status_CodesTableAdapter" Name="Ref_Delivery_Status_Codes" UserDataComponentName="Ref_Delivery_Status_CodesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Ref_Delivery_Status_Codes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Ref_Delivery_Status_Codes] WHERE (([delivery_status_code] = @Original_delivery_status_code) AND ((@IsNull_delivery_status_description = 1 AND [delivery_status_description] IS NULL) OR ([delivery_status_description] = @Original_delivery_status_description)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_delivery_status_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_delivery_status_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="delivery_status_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_delivery_status_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Ref_Delivery_Status_Codes] ([delivery_status_code], [delivery_status_description]) VALUES (@delivery_status_code, @delivery_status_description);
SELECT delivery_status_code, delivery_status_description FROM Ref_Delivery_Status_Codes WHERE (delivery_status_code = @delivery_status_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@delivery_status_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@delivery_status_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT delivery_status_code, delivery_status_description FROM dbo.Ref_Delivery_Status_Codes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Ref_Delivery_Status_Codes] SET [delivery_status_code] = @delivery_status_code, [delivery_status_description] = @delivery_status_description WHERE (([delivery_status_code] = @Original_delivery_status_code) AND ((@IsNull_delivery_status_description = 1 AND [delivery_status_description] IS NULL) OR ([delivery_status_description] = @Original_delivery_status_description)));
SELECT delivery_status_code, delivery_status_description FROM Ref_Delivery_Status_Codes WHERE (delivery_status_code = @delivery_status_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@delivery_status_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@delivery_status_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_delivery_status_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_delivery_status_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="delivery_status_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_delivery_status_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="delivery_status_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="delivery_status_code" DataSetColumn="delivery_status_code" />
              <Mapping SourceColumn="delivery_status_description" DataSetColumn="delivery_status_description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Ref_Order_Status_CodesTableAdapter" GeneratorDataComponentClassName="Ref_Order_Status_CodesTableAdapter" Name="Ref_Order_Status_Codes" UserDataComponentName="Ref_Order_Status_CodesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Ref_Order_Status_Codes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Ref_Order_Status_Codes] WHERE (([order_status_code] = @Original_order_status_code) AND ((@IsNull_order_status_description = 1 AND [order_status_description] IS NULL) OR ([order_status_description] = @Original_order_status_description)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_order_status_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="order_status_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_order_status_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_status_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_order_status_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="order_status_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Ref_Order_Status_Codes] ([order_status_code], [order_status_description]) VALUES (@order_status_code, @order_status_description);
SELECT order_status_code, order_status_description FROM Ref_Order_Status_Codes WHERE (order_status_code = @order_status_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@order_status_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="order_status_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@order_status_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="order_status_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT order_status_code, order_status_description FROM dbo.Ref_Order_Status_Codes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Ref_Order_Status_Codes] SET [order_status_code] = @order_status_code, [order_status_description] = @order_status_description WHERE (([order_status_code] = @Original_order_status_code) AND ((@IsNull_order_status_description = 1 AND [order_status_description] IS NULL) OR ([order_status_description] = @Original_order_status_description)));
SELECT order_status_code, order_status_description FROM Ref_Order_Status_Codes WHERE (order_status_code = @order_status_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@order_status_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="order_status_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@order_status_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="order_status_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_order_status_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="order_status_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_order_status_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="order_status_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_order_status_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="order_status_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="order_status_code" DataSetColumn="order_status_code" />
              <Mapping SourceColumn="order_status_description" DataSetColumn="order_status_description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Ref_Payment_MethodsTableAdapter" GeneratorDataComponentClassName="Ref_Payment_MethodsTableAdapter" Name="Ref_Payment_Methods" UserDataComponentName="Ref_Payment_MethodsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Ref_Payment_Methods" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Ref_Payment_Methods] WHERE (([payment_method_code] = @Original_payment_method_code) AND ((@IsNull_payment_method_description = 1 AND [payment_method_description] IS NULL) OR ([payment_method_description] = @Original_payment_method_description)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_payment_method_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="payment_method_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_payment_method_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="payment_method_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_payment_method_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="payment_method_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Ref_Payment_Methods] ([payment_method_code], [payment_method_description]) VALUES (@payment_method_code, @payment_method_description);
SELECT payment_method_code, payment_method_description FROM Ref_Payment_Methods WHERE (payment_method_code = @payment_method_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@payment_method_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="payment_method_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@payment_method_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="payment_method_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT payment_method_code, payment_method_description FROM dbo.Ref_Payment_Methods</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Ref_Payment_Methods] SET [payment_method_code] = @payment_method_code, [payment_method_description] = @payment_method_description WHERE (([payment_method_code] = @Original_payment_method_code) AND ((@IsNull_payment_method_description = 1 AND [payment_method_description] IS NULL) OR ([payment_method_description] = @Original_payment_method_description)));
SELECT payment_method_code, payment_method_description FROM Ref_Payment_Methods WHERE (payment_method_code = @payment_method_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@payment_method_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="payment_method_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@payment_method_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="payment_method_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_payment_method_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="payment_method_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_payment_method_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="payment_method_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_payment_method_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="payment_method_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="payment_method_code" DataSetColumn="payment_method_code" />
              <Mapping SourceColumn="payment_method_description" DataSetColumn="payment_method_description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Ref_Product_TypesTableAdapter" GeneratorDataComponentClassName="Ref_Product_TypesTableAdapter" Name="Ref_Product_Types" UserDataComponentName="Ref_Product_TypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Ref_Product_Types" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Ref_Product_Types] WHERE (([product_type_code] = @Original_product_type_code) AND ((@IsNull_level_number = 1 AND [level_number] IS NULL) OR ([level_number] = @Original_level_number)) AND ((@IsNull_parent_product_type_code = 1 AND [parent_product_type_code] IS NULL) OR ([parent_product_type_code] = @Original_parent_product_type_code)) AND ((@IsNull_product_type_description = 1 AND [product_type_description] IS NULL) OR ([product_type_description] = @Original_product_type_description)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="product_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_level_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="level_number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_level_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="level_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parent_product_type_code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parent_product_type_code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parent_product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parent_product_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_product_type_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_type_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_product_type_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="product_type_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Ref_Product_Types] ([product_type_code], [level_number], [parent_product_type_code], [product_type_description]) VALUES (@product_type_code, @level_number, @parent_product_type_code, @product_type_description);
SELECT product_type_code, level_number, parent_product_type_code, product_type_description FROM Ref_Product_Types WHERE (product_type_code = @product_type_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="product_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@level_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="level_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parent_product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parent_product_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@product_type_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="product_type_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT product_type_code, level_number, parent_product_type_code, product_type_description FROM dbo.Ref_Product_Types</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Ref_Product_Types] SET [product_type_code] = @product_type_code, [level_number] = @level_number, [parent_product_type_code] = @parent_product_type_code, [product_type_description] = @product_type_description WHERE (([product_type_code] = @Original_product_type_code) AND ((@IsNull_level_number = 1 AND [level_number] IS NULL) OR ([level_number] = @Original_level_number)) AND ((@IsNull_parent_product_type_code = 1 AND [parent_product_type_code] IS NULL) OR ([parent_product_type_code] = @Original_parent_product_type_code)) AND ((@IsNull_product_type_description = 1 AND [product_type_description] IS NULL) OR ([product_type_description] = @Original_product_type_description)));
SELECT product_type_code, level_number, parent_product_type_code, product_type_description FROM Ref_Product_Types WHERE (product_type_code = @product_type_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="product_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@level_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="level_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@parent_product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parent_product_type_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@product_type_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="product_type_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="product_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_level_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="level_number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_level_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="level_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_parent_product_type_code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parent_product_type_code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_parent_product_type_code" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="parent_product_type_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_product_type_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="product_type_description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_product_type_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="product_type_description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="product_type_code" DataSetColumn="product_type_code" />
              <Mapping SourceColumn="level_number" DataSetColumn="level_number" />
              <Mapping SourceColumn="parent_product_type_code" DataSetColumn="parent_product_type_code" />
              <Mapping SourceColumn="product_type_description" DataSetColumn="product_type_description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SuppliersTableAdapter" GeneratorDataComponentClassName="SuppliersTableAdapter" Name="Suppliers" UserDataComponentName="SuppliersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Customers_and_OrdersConnectionString (MySettings)" DbObjectName="dbo.Suppliers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Suppliers] WHERE (([supplier_code] = @Original_supplier_code) AND ((@IsNull_supplier_name = 1 AND [supplier_name] IS NULL) OR ([supplier_name] = @Original_supplier_name)) AND ((@IsNull_other_supplier_details = 1 AND [other_supplier_details] IS NULL) OR ([other_supplier_details] = @Original_other_supplier_details)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_supplier_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_supplier_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="supplier_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_supplier_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_supplier_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_supplier_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_supplier_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_supplier_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Suppliers] ([supplier_code], [supplier_name], [other_supplier_details]) VALUES (@supplier_code, @supplier_name, @other_supplier_details);
SELECT supplier_code, supplier_name, other_supplier_details FROM Suppliers WHERE (supplier_code = @supplier_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@supplier_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@supplier_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_supplier_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_supplier_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT supplier_code, supplier_name, other_supplier_details FROM dbo.Suppliers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Suppliers] SET [supplier_code] = @supplier_code, [supplier_name] = @supplier_name, [other_supplier_details] = @other_supplier_details WHERE (([supplier_code] = @Original_supplier_code) AND ((@IsNull_supplier_name = 1 AND [supplier_name] IS NULL) OR ([supplier_name] = @Original_supplier_name)) AND ((@IsNull_other_supplier_details = 1 AND [other_supplier_details] IS NULL) OR ([other_supplier_details] = @Original_other_supplier_details)));
SELECT supplier_code, supplier_name, other_supplier_details FROM Suppliers WHERE (supplier_code = @supplier_code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@supplier_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@supplier_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@other_supplier_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_supplier_details" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_supplier_code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_supplier_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="supplier_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_supplier_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="supplier_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_other_supplier_details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="other_supplier_details" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_other_supplier_details" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="other_supplier_details" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="supplier_code" DataSetColumn="supplier_code" />
              <Mapping SourceColumn="supplier_name" DataSetColumn="supplier_name" />
              <Mapping SourceColumn="other_supplier_details" DataSetColumn="other_supplier_details" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Customers_and_OrdersDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Customers_and_OrdersDataSet" msprop:Generator_UserDSName="Customers_and_OrdersDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Addresses" msprop:Generator_TableClassName="AddressesDataTable" msprop:Generator_TableVarName="tableAddresses" msprop:Generator_TablePropName="Addresses" msprop:Generator_RowDeletingName="AddressesRowDeleting" msprop:Generator_UserTableName="Addresses" msprop:Generator_RowChangingName="AddressesRowChanging" msprop:Generator_RowEvHandlerName="AddressesRowChangeEventHandler" msprop:Generator_RowDeletedName="AddressesRowDeleted" msprop:Generator_RowEvArgName="AddressesRowChangeEvent" msprop:Generator_RowChangedName="AddressesRowChanged" msprop:Generator_RowClassName="AddressesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="address_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnaddress_id" msprop:Generator_ColumnPropNameInRow="address_id" msprop:Generator_ColumnPropNameInTable="address_idColumn" msprop:Generator_UserColumnName="address_id" type="xs:int" />
              <xs:element name="line_1" msprop:Generator_ColumnVarNameInTable="columnline_1" msprop:Generator_ColumnPropNameInRow="line_1" msprop:Generator_ColumnPropNameInTable="line_1Column" msprop:Generator_UserColumnName="line_1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="line_2" msprop:Generator_ColumnVarNameInTable="columnline_2" msprop:Generator_ColumnPropNameInRow="line_2" msprop:Generator_ColumnPropNameInTable="line_2Column" msprop:Generator_UserColumnName="line_2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="line_3" msprop:Generator_ColumnVarNameInTable="columnline_3" msprop:Generator_ColumnPropNameInRow="line_3" msprop:Generator_ColumnPropNameInTable="line_3Column" msprop:Generator_UserColumnName="line_3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="city" msprop:Generator_ColumnVarNameInTable="columncity" msprop:Generator_ColumnPropNameInRow="city" msprop:Generator_ColumnPropNameInTable="cityColumn" msprop:Generator_UserColumnName="city" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="zip_postcode" msprop:Generator_ColumnVarNameInTable="columnzip_postcode" msprop:Generator_ColumnPropNameInRow="zip_postcode" msprop:Generator_ColumnPropNameInTable="zip_postcodeColumn" msprop:Generator_UserColumnName="zip_postcode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="state_province_county" msprop:Generator_ColumnVarNameInTable="columnstate_province_county" msprop:Generator_ColumnPropNameInRow="state_province_county" msprop:Generator_ColumnPropNameInTable="state_province_countyColumn" msprop:Generator_UserColumnName="state_province_county" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iso_country_code" msprop:Generator_ColumnVarNameInTable="columniso_country_code" msprop:Generator_ColumnPropNameInRow="iso_country_code" msprop:Generator_ColumnPropNameInTable="iso_country_codeColumn" msprop:Generator_UserColumnName="iso_country_code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="other_address_details" msprop:Generator_ColumnVarNameInTable="columnother_address_details" msprop:Generator_ColumnPropNameInRow="other_address_details" msprop:Generator_ColumnPropNameInTable="other_address_detailsColumn" msprop:Generator_UserColumnName="other_address_details" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customer_Addresses" msprop:Generator_TableClassName="Customer_AddressesDataTable" msprop:Generator_TableVarName="tableCustomer_Addresses" msprop:Generator_TablePropName="Customer_Addresses" msprop:Generator_RowDeletingName="Customer_AddressesRowDeleting" msprop:Generator_UserTableName="Customer_Addresses" msprop:Generator_RowChangingName="Customer_AddressesRowChanging" msprop:Generator_RowEvHandlerName="Customer_AddressesRowChangeEventHandler" msprop:Generator_RowDeletedName="Customer_AddressesRowDeleted" msprop:Generator_RowEvArgName="Customer_AddressesRowChangeEvent" msprop:Generator_RowChangedName="Customer_AddressesRowChanged" msprop:Generator_RowClassName="Customer_AddressesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="customer_id" msprop:Generator_ColumnVarNameInTable="columncustomer_id" msprop:Generator_ColumnPropNameInRow="customer_id" msprop:Generator_ColumnPropNameInTable="customer_idColumn" msprop:Generator_UserColumnName="customer_id" type="xs:int" />
              <xs:element name="address_id" msprop:Generator_ColumnVarNameInTable="columnaddress_id" msprop:Generator_ColumnPropNameInRow="address_id" msprop:Generator_ColumnPropNameInTable="address_idColumn" msprop:Generator_UserColumnName="address_id" type="xs:int" />
              <xs:element name="date_from" msprop:Generator_ColumnVarNameInTable="columndate_from" msprop:Generator_ColumnPropNameInRow="date_from" msprop:Generator_ColumnPropNameInTable="date_fromColumn" msprop:Generator_UserColumnName="date_from" type="xs:dateTime" />
              <xs:element name="address_type_code" msprop:Generator_ColumnVarNameInTable="columnaddress_type_code" msprop:Generator_ColumnPropNameInRow="address_type_code" msprop:Generator_ColumnPropNameInTable="address_type_codeColumn" msprop:Generator_UserColumnName="address_type_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_to" msprop:Generator_ColumnVarNameInTable="columndate_to" msprop:Generator_ColumnPropNameInRow="date_to" msprop:Generator_ColumnPropNameInTable="date_toColumn" msprop:Generator_UserColumnName="date_to" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customer_Orders" msprop:Generator_TableClassName="Customer_OrdersDataTable" msprop:Generator_TableVarName="tableCustomer_Orders" msprop:Generator_TablePropName="Customer_Orders" msprop:Generator_RowDeletingName="Customer_OrdersRowDeleting" msprop:Generator_UserTableName="Customer_Orders" msprop:Generator_RowChangingName="Customer_OrdersRowChanging" msprop:Generator_RowEvHandlerName="Customer_OrdersRowChangeEventHandler" msprop:Generator_RowDeletedName="Customer_OrdersRowDeleted" msprop:Generator_RowEvArgName="Customer_OrdersRowChangeEvent" msprop:Generator_RowChangedName="Customer_OrdersRowChanged" msprop:Generator_RowClassName="Customer_OrdersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="order_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnorder_id" msprop:Generator_ColumnPropNameInRow="order_id" msprop:Generator_ColumnPropNameInTable="order_idColumn" msprop:Generator_UserColumnName="order_id" type="xs:int" />
              <xs:element name="customer_id" msprop:Generator_ColumnVarNameInTable="columncustomer_id" msprop:Generator_ColumnPropNameInRow="customer_id" msprop:Generator_ColumnPropNameInTable="customer_idColumn" msprop:Generator_UserColumnName="customer_id" type="xs:int" />
              <xs:element name="customer_payment_method_id" msprop:Generator_ColumnVarNameInTable="columncustomer_payment_method_id" msprop:Generator_ColumnPropNameInRow="customer_payment_method_id" msprop:Generator_ColumnPropNameInTable="customer_payment_method_idColumn" msprop:Generator_UserColumnName="customer_payment_method_id" type="xs:int" />
              <xs:element name="order_status_code" msprop:Generator_ColumnVarNameInTable="columnorder_status_code" msprop:Generator_ColumnPropNameInRow="order_status_code" msprop:Generator_ColumnPropNameInTable="order_status_codeColumn" msprop:Generator_UserColumnName="order_status_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_order_placed" msprop:Generator_ColumnVarNameInTable="columndate_order_placed" msprop:Generator_ColumnPropNameInRow="date_order_placed" msprop:Generator_ColumnPropNameInTable="date_order_placedColumn" msprop:Generator_UserColumnName="date_order_placed" type="xs:dateTime" />
              <xs:element name="date_order_paid" msprop:Generator_ColumnVarNameInTable="columndate_order_paid" msprop:Generator_ColumnPropNameInRow="date_order_paid" msprop:Generator_ColumnPropNameInTable="date_order_paidColumn" msprop:Generator_UserColumnName="date_order_paid" type="xs:dateTime" minOccurs="0" />
              <xs:element name="der_total_order_price" msprop:Generator_ColumnVarNameInTable="columnder_total_order_price" msprop:Generator_ColumnPropNameInRow="der_total_order_price" msprop:Generator_ColumnPropNameInTable="der_total_order_priceColumn" msprop:Generator_UserColumnName="der_total_order_price" type="xs:decimal" minOccurs="0" />
              <xs:element name="other_order_details" msprop:Generator_ColumnVarNameInTable="columnother_order_details" msprop:Generator_ColumnPropNameInRow="other_order_details" msprop:Generator_ColumnPropNameInTable="other_order_detailsColumn" msprop:Generator_UserColumnName="other_order_details" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customer_Orders_Delivery" msprop:Generator_TableClassName="Customer_Orders_DeliveryDataTable" msprop:Generator_TableVarName="tableCustomer_Orders_Delivery" msprop:Generator_TablePropName="Customer_Orders_Delivery" msprop:Generator_RowDeletingName="Customer_Orders_DeliveryRowDeleting" msprop:Generator_UserTableName="Customer_Orders_Delivery" msprop:Generator_RowChangingName="Customer_Orders_DeliveryRowChanging" msprop:Generator_RowEvHandlerName="Customer_Orders_DeliveryRowChangeEventHandler" msprop:Generator_RowDeletedName="Customer_Orders_DeliveryRowDeleted" msprop:Generator_RowEvArgName="Customer_Orders_DeliveryRowChangeEvent" msprop:Generator_RowChangedName="Customer_Orders_DeliveryRowChanged" msprop:Generator_RowClassName="Customer_Orders_DeliveryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="order_id" msprop:Generator_ColumnVarNameInTable="columnorder_id" msprop:Generator_ColumnPropNameInRow="order_id" msprop:Generator_ColumnPropNameInTable="order_idColumn" msprop:Generator_UserColumnName="order_id" type="xs:int" />
              <xs:element name="date_reported" msprop:Generator_ColumnVarNameInTable="columndate_reported" msprop:Generator_ColumnPropNameInRow="date_reported" msprop:Generator_ColumnPropNameInTable="date_reportedColumn" msprop:Generator_UserColumnName="date_reported" type="xs:dateTime" />
              <xs:element name="delivery_status_code" msprop:Generator_ColumnVarNameInTable="columndelivery_status_code" msprop:Generator_ColumnPropNameInRow="delivery_status_code" msprop:Generator_ColumnPropNameInTable="delivery_status_codeColumn" msprop:Generator_UserColumnName="delivery_status_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customer_Orders_Products" msprop:Generator_TableClassName="Customer_Orders_ProductsDataTable" msprop:Generator_TableVarName="tableCustomer_Orders_Products" msprop:Generator_TablePropName="Customer_Orders_Products" msprop:Generator_RowDeletingName="Customer_Orders_ProductsRowDeleting" msprop:Generator_UserTableName="Customer_Orders_Products" msprop:Generator_RowChangingName="Customer_Orders_ProductsRowChanging" msprop:Generator_RowEvHandlerName="Customer_Orders_ProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="Customer_Orders_ProductsRowDeleted" msprop:Generator_RowEvArgName="Customer_Orders_ProductsRowChangeEvent" msprop:Generator_RowChangedName="Customer_Orders_ProductsRowChanged" msprop:Generator_RowClassName="Customer_Orders_ProductsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="order_id" msprop:Generator_ColumnVarNameInTable="columnorder_id" msprop:Generator_ColumnPropNameInRow="order_id" msprop:Generator_ColumnPropNameInTable="order_idColumn" msprop:Generator_UserColumnName="order_id" type="xs:int" />
              <xs:element name="product_id" msprop:Generator_ColumnVarNameInTable="columnproduct_id" msprop:Generator_ColumnPropNameInRow="product_id" msprop:Generator_ColumnPropNameInTable="product_idColumn" msprop:Generator_UserColumnName="product_id" type="xs:int" />
              <xs:element name="quantity" msprop:Generator_ColumnVarNameInTable="columnquantity" msprop:Generator_ColumnPropNameInRow="quantity" msprop:Generator_ColumnPropNameInTable="quantityColumn" msprop:Generator_UserColumnName="quantity" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="comments" msprop:Generator_ColumnVarNameInTable="columncomments" msprop:Generator_ColumnPropNameInRow="comments" msprop:Generator_ColumnPropNameInTable="commentsColumn" msprop:Generator_UserColumnName="comments" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customers" msprop:Generator_TableClassName="CustomersDataTable" msprop:Generator_TableVarName="tableCustomers" msprop:Generator_TablePropName="Customers" msprop:Generator_RowDeletingName="CustomersRowDeleting" msprop:Generator_UserTableName="Customers" msprop:Generator_RowChangingName="CustomersRowChanging" msprop:Generator_RowEvHandlerName="CustomersRowChangeEventHandler" msprop:Generator_RowDeletedName="CustomersRowDeleted" msprop:Generator_RowEvArgName="CustomersRowChangeEvent" msprop:Generator_RowChangedName="CustomersRowChanged" msprop:Generator_RowClassName="CustomersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="customer_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncustomer_id" msprop:Generator_ColumnPropNameInRow="customer_id" msprop:Generator_ColumnPropNameInTable="customer_idColumn" msprop:Generator_UserColumnName="customer_id" type="xs:int" />
              <xs:element name="first_name" msprop:Generator_ColumnVarNameInTable="columnfirst_name" msprop:Generator_ColumnPropNameInRow="first_name" msprop:Generator_ColumnPropNameInTable="first_nameColumn" msprop:Generator_UserColumnName="first_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="middle_name" msprop:Generator_ColumnVarNameInTable="columnmiddle_name" msprop:Generator_ColumnPropNameInRow="middle_name" msprop:Generator_ColumnPropNameInTable="middle_nameColumn" msprop:Generator_UserColumnName="middle_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="last_name" msprop:Generator_ColumnVarNameInTable="columnlast_name" msprop:Generator_ColumnPropNameInRow="last_name" msprop:Generator_ColumnPropNameInTable="last_nameColumn" msprop:Generator_UserColumnName="last_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="customer_phone" msprop:Generator_ColumnVarNameInTable="columncustomer_phone" msprop:Generator_ColumnPropNameInRow="customer_phone" msprop:Generator_ColumnPropNameInTable="customer_phoneColumn" msprop:Generator_UserColumnName="customer_phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="customer_email" msprop:Generator_ColumnVarNameInTable="columncustomer_email" msprop:Generator_ColumnPropNameInRow="customer_email" msprop:Generator_ColumnPropNameInTable="customer_emailColumn" msprop:Generator_UserColumnName="customer_email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="other_customer_details" msprop:Generator_ColumnVarNameInTable="columnother_customer_details" msprop:Generator_ColumnPropNameInRow="other_customer_details" msprop:Generator_ColumnPropNameInTable="other_customer_detailsColumn" msprop:Generator_UserColumnName="other_customer_details" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customers_Payment_Methods" msprop:Generator_TableClassName="Customers_Payment_MethodsDataTable" msprop:Generator_TableVarName="tableCustomers_Payment_Methods" msprop:Generator_TablePropName="Customers_Payment_Methods" msprop:Generator_RowDeletingName="Customers_Payment_MethodsRowDeleting" msprop:Generator_UserTableName="Customers_Payment_Methods" msprop:Generator_RowChangingName="Customers_Payment_MethodsRowChanging" msprop:Generator_RowEvHandlerName="Customers_Payment_MethodsRowChangeEventHandler" msprop:Generator_RowDeletedName="Customers_Payment_MethodsRowDeleted" msprop:Generator_RowEvArgName="Customers_Payment_MethodsRowChangeEvent" msprop:Generator_RowChangedName="Customers_Payment_MethodsRowChanged" msprop:Generator_RowClassName="Customers_Payment_MethodsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="customer_payment_method_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columncustomer_payment_method_id" msprop:Generator_ColumnPropNameInRow="customer_payment_method_id" msprop:Generator_ColumnPropNameInTable="customer_payment_method_idColumn" msprop:Generator_UserColumnName="customer_payment_method_id" type="xs:int" />
              <xs:element name="customer_id" msprop:Generator_ColumnVarNameInTable="columncustomer_id" msprop:Generator_ColumnPropNameInRow="customer_id" msprop:Generator_ColumnPropNameInTable="customer_idColumn" msprop:Generator_UserColumnName="customer_id" type="xs:int" />
              <xs:element name="payment_method_code" msprop:Generator_ColumnVarNameInTable="columnpayment_method_code" msprop:Generator_ColumnPropNameInRow="payment_method_code" msprop:Generator_ColumnPropNameInTable="payment_method_codeColumn" msprop:Generator_UserColumnName="payment_method_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="card_number" msprop:Generator_ColumnVarNameInTable="columncard_number" msprop:Generator_ColumnPropNameInRow="card_number" msprop:Generator_ColumnPropNameInTable="card_numberColumn" msprop:Generator_UserColumnName="card_number" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_from" msprop:Generator_ColumnVarNameInTable="columndate_from" msprop:Generator_ColumnPropNameInRow="date_from" msprop:Generator_ColumnPropNameInTable="date_fromColumn" msprop:Generator_UserColumnName="date_from" type="xs:dateTime" minOccurs="0" />
              <xs:element name="date_to" msprop:Generator_ColumnVarNameInTable="columndate_to" msprop:Generator_ColumnPropNameInRow="date_to" msprop:Generator_ColumnPropNameInTable="date_toColumn" msprop:Generator_UserColumnName="date_to" type="xs:dateTime" minOccurs="0" />
              <xs:element name="other_details" msprop:Generator_ColumnVarNameInTable="columnother_details" msprop:Generator_ColumnPropNameInRow="other_details" msprop:Generator_ColumnPropNameInTable="other_detailsColumn" msprop:Generator_UserColumnName="other_details" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Products" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_TableVarName="tableProducts" msprop:Generator_TablePropName="Products" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_UserTableName="Products" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowClassName="ProductsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="product_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnproduct_id" msprop:Generator_ColumnPropNameInRow="product_id" msprop:Generator_ColumnPropNameInTable="product_idColumn" msprop:Generator_UserColumnName="product_id" type="xs:int" />
              <xs:element name="product_type_code" msprop:Generator_ColumnVarNameInTable="columnproduct_type_code" msprop:Generator_ColumnPropNameInRow="product_type_code" msprop:Generator_ColumnPropNameInTable="product_type_codeColumn" msprop:Generator_UserColumnName="product_type_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="supplier_code" msprop:Generator_ColumnVarNameInTable="columnsupplier_code" msprop:Generator_ColumnPropNameInRow="supplier_code" msprop:Generator_ColumnPropNameInTable="supplier_codeColumn" msprop:Generator_UserColumnName="supplier_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="product_price" msprop:Generator_ColumnVarNameInTable="columnproduct_price" msprop:Generator_ColumnPropNameInRow="product_price" msprop:Generator_ColumnPropNameInTable="product_priceColumn" msprop:Generator_UserColumnName="product_price" type="xs:decimal" minOccurs="0" />
              <xs:element name="book_isbn" msprop:Generator_ColumnVarNameInTable="columnbook_isbn" msprop:Generator_ColumnPropNameInRow="book_isbn" msprop:Generator_ColumnPropNameInTable="book_isbnColumn" msprop:Generator_UserColumnName="book_isbn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="book_author" msprop:Generator_ColumnVarNameInTable="columnbook_author" msprop:Generator_ColumnPropNameInRow="book_author" msprop:Generator_ColumnPropNameInTable="book_authorColumn" msprop:Generator_UserColumnName="book_author" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="book_publication_date" msprop:Generator_ColumnVarNameInTable="columnbook_publication_date" msprop:Generator_ColumnPropNameInRow="book_publication_date" msprop:Generator_ColumnPropNameInTable="book_publication_dateColumn" msprop:Generator_UserColumnName="book_publication_date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="book_title" msprop:Generator_ColumnVarNameInTable="columnbook_title" msprop:Generator_ColumnPropNameInRow="book_title" msprop:Generator_ColumnPropNameInTable="book_titleColumn" msprop:Generator_UserColumnName="book_title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="book_price" msprop:Generator_ColumnVarNameInTable="columnbook_price" msprop:Generator_ColumnPropNameInRow="book_price" msprop:Generator_ColumnPropNameInTable="book_priceColumn" msprop:Generator_UserColumnName="book_price" type="xs:decimal" minOccurs="0" />
              <xs:element name="food_contains_yn" msprop:Generator_ColumnVarNameInTable="columnfood_contains_yn" msprop:Generator_ColumnPropNameInRow="food_contains_yn" msprop:Generator_ColumnPropNameInTable="food_contains_ynColumn" msprop:Generator_UserColumnName="food_contains_yn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="food_name" msprop:Generator_ColumnVarNameInTable="columnfood_name" msprop:Generator_ColumnPropNameInRow="food_name" msprop:Generator_ColumnPropNameInTable="food_nameColumn" msprop:Generator_UserColumnName="food_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="food_description" msprop:Generator_ColumnVarNameInTable="columnfood_description" msprop:Generator_ColumnPropNameInRow="food_description" msprop:Generator_ColumnPropNameInTable="food_descriptionColumn" msprop:Generator_UserColumnName="food_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="food_flavor" msprop:Generator_ColumnVarNameInTable="columnfood_flavor" msprop:Generator_ColumnPropNameInRow="food_flavor" msprop:Generator_ColumnPropNameInTable="food_flavorColumn" msprop:Generator_UserColumnName="food_flavor" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="food_ingredients" msprop:Generator_ColumnVarNameInTable="columnfood_ingredients" msprop:Generator_ColumnPropNameInRow="food_ingredients" msprop:Generator_ColumnPropNameInTable="food_ingredientsColumn" msprop:Generator_UserColumnName="food_ingredients" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="other_product_details" msprop:Generator_ColumnVarNameInTable="columnother_product_details" msprop:Generator_ColumnPropNameInRow="other_product_details" msprop:Generator_ColumnPropNameInTable="other_product_detailsColumn" msprop:Generator_UserColumnName="other_product_details" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Ref_Address_Types" msprop:Generator_TableClassName="Ref_Address_TypesDataTable" msprop:Generator_TableVarName="tableRef_Address_Types" msprop:Generator_TablePropName="Ref_Address_Types" msprop:Generator_RowDeletingName="Ref_Address_TypesRowDeleting" msprop:Generator_UserTableName="Ref_Address_Types" msprop:Generator_RowChangingName="Ref_Address_TypesRowChanging" msprop:Generator_RowEvHandlerName="Ref_Address_TypesRowChangeEventHandler" msprop:Generator_RowDeletedName="Ref_Address_TypesRowDeleted" msprop:Generator_RowEvArgName="Ref_Address_TypesRowChangeEvent" msprop:Generator_RowChangedName="Ref_Address_TypesRowChanged" msprop:Generator_RowClassName="Ref_Address_TypesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="address_type_code" msprop:Generator_ColumnVarNameInTable="columnaddress_type_code" msprop:Generator_ColumnPropNameInRow="address_type_code" msprop:Generator_ColumnPropNameInTable="address_type_codeColumn" msprop:Generator_UserColumnName="address_type_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="address_type_description" msprop:Generator_ColumnVarNameInTable="columnaddress_type_description" msprop:Generator_ColumnPropNameInRow="address_type_description" msprop:Generator_ColumnPropNameInTable="address_type_descriptionColumn" msprop:Generator_UserColumnName="address_type_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Ref_Delivery_Status_Codes" msprop:Generator_TableClassName="Ref_Delivery_Status_CodesDataTable" msprop:Generator_TableVarName="tableRef_Delivery_Status_Codes" msprop:Generator_TablePropName="Ref_Delivery_Status_Codes" msprop:Generator_RowDeletingName="Ref_Delivery_Status_CodesRowDeleting" msprop:Generator_UserTableName="Ref_Delivery_Status_Codes" msprop:Generator_RowChangingName="Ref_Delivery_Status_CodesRowChanging" msprop:Generator_RowEvHandlerName="Ref_Delivery_Status_CodesRowChangeEventHandler" msprop:Generator_RowDeletedName="Ref_Delivery_Status_CodesRowDeleted" msprop:Generator_RowEvArgName="Ref_Delivery_Status_CodesRowChangeEvent" msprop:Generator_RowChangedName="Ref_Delivery_Status_CodesRowChanged" msprop:Generator_RowClassName="Ref_Delivery_Status_CodesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="delivery_status_code" msprop:Generator_ColumnVarNameInTable="columndelivery_status_code" msprop:Generator_ColumnPropNameInRow="delivery_status_code" msprop:Generator_ColumnPropNameInTable="delivery_status_codeColumn" msprop:Generator_UserColumnName="delivery_status_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="delivery_status_description" msprop:Generator_ColumnVarNameInTable="columndelivery_status_description" msprop:Generator_ColumnPropNameInRow="delivery_status_description" msprop:Generator_ColumnPropNameInTable="delivery_status_descriptionColumn" msprop:Generator_UserColumnName="delivery_status_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Ref_Order_Status_Codes" msprop:Generator_TableClassName="Ref_Order_Status_CodesDataTable" msprop:Generator_TableVarName="tableRef_Order_Status_Codes" msprop:Generator_TablePropName="Ref_Order_Status_Codes" msprop:Generator_RowDeletingName="Ref_Order_Status_CodesRowDeleting" msprop:Generator_UserTableName="Ref_Order_Status_Codes" msprop:Generator_RowChangingName="Ref_Order_Status_CodesRowChanging" msprop:Generator_RowEvHandlerName="Ref_Order_Status_CodesRowChangeEventHandler" msprop:Generator_RowDeletedName="Ref_Order_Status_CodesRowDeleted" msprop:Generator_RowEvArgName="Ref_Order_Status_CodesRowChangeEvent" msprop:Generator_RowChangedName="Ref_Order_Status_CodesRowChanged" msprop:Generator_RowClassName="Ref_Order_Status_CodesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="order_status_code" msprop:Generator_ColumnVarNameInTable="columnorder_status_code" msprop:Generator_ColumnPropNameInRow="order_status_code" msprop:Generator_ColumnPropNameInTable="order_status_codeColumn" msprop:Generator_UserColumnName="order_status_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="order_status_description" msprop:Generator_ColumnVarNameInTable="columnorder_status_description" msprop:Generator_ColumnPropNameInRow="order_status_description" msprop:Generator_ColumnPropNameInTable="order_status_descriptionColumn" msprop:Generator_UserColumnName="order_status_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Ref_Payment_Methods" msprop:Generator_TableClassName="Ref_Payment_MethodsDataTable" msprop:Generator_TableVarName="tableRef_Payment_Methods" msprop:Generator_TablePropName="Ref_Payment_Methods" msprop:Generator_RowDeletingName="Ref_Payment_MethodsRowDeleting" msprop:Generator_UserTableName="Ref_Payment_Methods" msprop:Generator_RowChangingName="Ref_Payment_MethodsRowChanging" msprop:Generator_RowEvHandlerName="Ref_Payment_MethodsRowChangeEventHandler" msprop:Generator_RowDeletedName="Ref_Payment_MethodsRowDeleted" msprop:Generator_RowEvArgName="Ref_Payment_MethodsRowChangeEvent" msprop:Generator_RowChangedName="Ref_Payment_MethodsRowChanged" msprop:Generator_RowClassName="Ref_Payment_MethodsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="payment_method_code" msprop:Generator_ColumnVarNameInTable="columnpayment_method_code" msprop:Generator_ColumnPropNameInRow="payment_method_code" msprop:Generator_ColumnPropNameInTable="payment_method_codeColumn" msprop:Generator_UserColumnName="payment_method_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="payment_method_description" msprop:Generator_ColumnVarNameInTable="columnpayment_method_description" msprop:Generator_ColumnPropNameInRow="payment_method_description" msprop:Generator_ColumnPropNameInTable="payment_method_descriptionColumn" msprop:Generator_UserColumnName="payment_method_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Ref_Product_Types" msprop:Generator_TableClassName="Ref_Product_TypesDataTable" msprop:Generator_TableVarName="tableRef_Product_Types" msprop:Generator_TablePropName="Ref_Product_Types" msprop:Generator_RowDeletingName="Ref_Product_TypesRowDeleting" msprop:Generator_UserTableName="Ref_Product_Types" msprop:Generator_RowChangingName="Ref_Product_TypesRowChanging" msprop:Generator_RowEvHandlerName="Ref_Product_TypesRowChangeEventHandler" msprop:Generator_RowDeletedName="Ref_Product_TypesRowDeleted" msprop:Generator_RowEvArgName="Ref_Product_TypesRowChangeEvent" msprop:Generator_RowChangedName="Ref_Product_TypesRowChanged" msprop:Generator_RowClassName="Ref_Product_TypesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="product_type_code" msprop:Generator_ColumnVarNameInTable="columnproduct_type_code" msprop:Generator_ColumnPropNameInRow="product_type_code" msprop:Generator_ColumnPropNameInTable="product_type_codeColumn" msprop:Generator_UserColumnName="product_type_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="level_number" msprop:Generator_ColumnVarNameInTable="columnlevel_number" msprop:Generator_ColumnPropNameInRow="level_number" msprop:Generator_ColumnPropNameInTable="level_numberColumn" msprop:Generator_UserColumnName="level_number" type="xs:int" minOccurs="0" />
              <xs:element name="parent_product_type_code" msprop:Generator_ColumnVarNameInTable="columnparent_product_type_code" msprop:Generator_ColumnPropNameInRow="parent_product_type_code" msprop:Generator_ColumnPropNameInTable="parent_product_type_codeColumn" msprop:Generator_UserColumnName="parent_product_type_code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="product_type_description" msprop:Generator_ColumnVarNameInTable="columnproduct_type_description" msprop:Generator_ColumnPropNameInRow="product_type_description" msprop:Generator_ColumnPropNameInTable="product_type_descriptionColumn" msprop:Generator_UserColumnName="product_type_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Suppliers" msprop:Generator_TableClassName="SuppliersDataTable" msprop:Generator_TableVarName="tableSuppliers" msprop:Generator_TablePropName="Suppliers" msprop:Generator_RowDeletingName="SuppliersRowDeleting" msprop:Generator_UserTableName="Suppliers" msprop:Generator_RowChangingName="SuppliersRowChanging" msprop:Generator_RowEvHandlerName="SuppliersRowChangeEventHandler" msprop:Generator_RowDeletedName="SuppliersRowDeleted" msprop:Generator_RowEvArgName="SuppliersRowChangeEvent" msprop:Generator_RowChangedName="SuppliersRowChanged" msprop:Generator_RowClassName="SuppliersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="supplier_code" msprop:Generator_ColumnVarNameInTable="columnsupplier_code" msprop:Generator_ColumnPropNameInRow="supplier_code" msprop:Generator_ColumnPropNameInTable="supplier_codeColumn" msprop:Generator_UserColumnName="supplier_code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="supplier_name" msprop:Generator_ColumnVarNameInTable="columnsupplier_name" msprop:Generator_ColumnPropNameInRow="supplier_name" msprop:Generator_ColumnPropNameInTable="supplier_nameColumn" msprop:Generator_UserColumnName="supplier_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="other_supplier_details" msprop:Generator_ColumnVarNameInTable="columnother_supplier_details" msprop:Generator_ColumnPropNameInRow="other_supplier_details" msprop:Generator_ColumnPropNameInTable="other_supplier_detailsColumn" msprop:Generator_UserColumnName="other_supplier_details" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Addresses" />
      <xs:field xpath="mstns:address_id" />
    </xs:unique>
    <xs:unique name="Customer_Addresses_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customer_Addresses" />
      <xs:field xpath="mstns:customer_id" />
      <xs:field xpath="mstns:address_id" />
      <xs:field xpath="mstns:date_from" />
    </xs:unique>
    <xs:unique name="Customer_Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customer_Orders" />
      <xs:field xpath="mstns:order_id" />
    </xs:unique>
    <xs:unique name="Customer_Orders_Delivery_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customer_Orders_Delivery" />
      <xs:field xpath="mstns:order_id" />
      <xs:field xpath="mstns:date_reported" />
    </xs:unique>
    <xs:unique name="Customer_Orders_Products_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customer_Orders_Products" />
      <xs:field xpath="mstns:order_id" />
      <xs:field xpath="mstns:product_id" />
    </xs:unique>
    <xs:unique name="Customers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customers" />
      <xs:field xpath="mstns:customer_id" />
    </xs:unique>
    <xs:unique name="Customers_Payment_Methods_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customers_Payment_Methods" />
      <xs:field xpath="mstns:customer_payment_method_id" />
    </xs:unique>
    <xs:unique name="Products_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Products" />
      <xs:field xpath="mstns:product_id" />
    </xs:unique>
    <xs:unique name="Ref_Address_Types_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Ref_Address_Types" />
      <xs:field xpath="mstns:address_type_code" />
    </xs:unique>
    <xs:unique name="Ref_Delivery_Status_Codes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Ref_Delivery_Status_Codes" />
      <xs:field xpath="mstns:delivery_status_code" />
    </xs:unique>
    <xs:unique name="Ref_Order_Status_Codes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Ref_Order_Status_Codes" />
      <xs:field xpath="mstns:order_status_code" />
    </xs:unique>
    <xs:unique name="Ref_Payment_Methods_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Ref_Payment_Methods" />
      <xs:field xpath="mstns:payment_method_code" />
    </xs:unique>
    <xs:unique name="Ref_Product_Types_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Ref_Product_Types" />
      <xs:field xpath="mstns:product_type_code" />
    </xs:unique>
    <xs:unique name="Suppliers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Suppliers" />
      <xs:field xpath="mstns:supplier_code" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="Addresses_Customer_Address_History" msdata:parent="Addresses" msdata:child="Customer_Addresses" msdata:parentkey="address_id" msdata:childkey="address_id" msprop:Generator_UserChildTable="Customer_Addresses" msprop:Generator_ChildPropName="GetCustomer_AddressesRows" msprop:Generator_ParentPropName="AddressesRow" msprop:Generator_UserRelationName="Addresses_Customer_Address_History" msprop:Generator_RelationVarName="relationAddresses_Customer_Address_History" msprop:Generator_UserParentTable="Addresses" />
      <msdata:Relationship name="Customers_Customer_Address_History" msdata:parent="Customers" msdata:child="Customer_Addresses" msdata:parentkey="customer_id" msdata:childkey="customer_id" msprop:Generator_UserChildTable="Customer_Addresses" msprop:Generator_ChildPropName="GetCustomer_AddressesRows" msprop:Generator_ParentPropName="CustomersRow" msprop:Generator_UserRelationName="Customers_Customer_Address_History" msprop:Generator_RelationVarName="relationCustomers_Customer_Address_History" msprop:Generator_UserParentTable="Customers" />
      <msdata:Relationship name="Ref_Address_Types_Customer_Address_History" msdata:parent="Ref_Address_Types" msdata:child="Customer_Addresses" msdata:parentkey="address_type_code" msdata:childkey="address_type_code" msprop:Generator_UserChildTable="Customer_Addresses" msprop:Generator_ChildPropName="GetCustomer_AddressesRows" msprop:Generator_ParentPropName="Ref_Address_TypesRow" msprop:Generator_UserRelationName="Ref_Address_Types_Customer_Address_History" msprop:Generator_RelationVarName="relationRef_Address_Types_Customer_Address_History" msprop:Generator_UserParentTable="Ref_Address_Types" />
      <msdata:Relationship name="Customers_Customer_Orders" msdata:parent="Customers" msdata:child="Customer_Orders" msdata:parentkey="customer_id" msdata:childkey="customer_id" msprop:Generator_UserChildTable="Customer_Orders" msprop:Generator_ChildPropName="GetCustomer_OrdersRows" msprop:Generator_ParentPropName="CustomersRow" msprop:Generator_UserRelationName="Customers_Customer_Orders" msprop:Generator_RelationVarName="relationCustomers_Customer_Orders" msprop:Generator_UserParentTable="Customers" />
      <msdata:Relationship name="Customers_Payment_Methods_Customer_Orders" msdata:parent="Customers_Payment_Methods" msdata:child="Customer_Orders" msdata:parentkey="customer_payment_method_id" msdata:childkey="customer_payment_method_id" msprop:Generator_UserChildTable="Customer_Orders" msprop:Generator_ChildPropName="GetCustomer_OrdersRows" msprop:Generator_ParentPropName="Customers_Payment_MethodsRow" msprop:Generator_UserRelationName="Customers_Payment_Methods_Customer_Orders" msprop:Generator_RelationVarName="relationCustomers_Payment_Methods_Customer_Orders" msprop:Generator_UserParentTable="Customers_Payment_Methods" />
      <msdata:Relationship name="Ref_Order_Status_Codes_Customer_Orders" msdata:parent="Ref_Order_Status_Codes" msdata:child="Customer_Orders" msdata:parentkey="order_status_code" msdata:childkey="order_status_code" msprop:Generator_UserChildTable="Customer_Orders" msprop:Generator_ChildPropName="GetCustomer_OrdersRows" msprop:Generator_ParentPropName="Ref_Order_Status_CodesRow" msprop:Generator_UserRelationName="Ref_Order_Status_Codes_Customer_Orders" msprop:Generator_RelationVarName="relationRef_Order_Status_Codes_Customer_Orders" msprop:Generator_UserParentTable="Ref_Order_Status_Codes" />
      <msdata:Relationship name="Customer_Orders_Customer_Orders_Delivery" msdata:parent="Customer_Orders" msdata:child="Customer_Orders_Delivery" msdata:parentkey="order_id" msdata:childkey="order_id" msprop:Generator_UserChildTable="Customer_Orders_Delivery" msprop:Generator_ChildPropName="GetCustomer_Orders_DeliveryRows" msprop:Generator_ParentPropName="Customer_OrdersRow" msprop:Generator_UserRelationName="Customer_Orders_Customer_Orders_Delivery" msprop:Generator_RelationVarName="relationCustomer_Orders_Customer_Orders_Delivery" msprop:Generator_UserParentTable="Customer_Orders" />
      <msdata:Relationship name="Ref_Delivery_Status_Codes_Customer_Orders_Delivery" msdata:parent="Ref_Delivery_Status_Codes" msdata:child="Customer_Orders_Delivery" msdata:parentkey="delivery_status_code" msdata:childkey="delivery_status_code" msprop:Generator_UserChildTable="Customer_Orders_Delivery" msprop:Generator_ChildPropName="GetCustomer_Orders_DeliveryRows" msprop:Generator_ParentPropName="Ref_Delivery_Status_CodesRow" msprop:Generator_UserRelationName="Ref_Delivery_Status_Codes_Customer_Orders_Delivery" msprop:Generator_RelationVarName="relationRef_Delivery_Status_Codes_Customer_Orders_Delivery" msprop:Generator_UserParentTable="Ref_Delivery_Status_Codes" />
      <msdata:Relationship name="Customer_Orders_Customer_Orders_Products" msdata:parent="Customer_Orders" msdata:child="Customer_Orders_Products" msdata:parentkey="order_id" msdata:childkey="order_id" msprop:Generator_UserChildTable="Customer_Orders_Products" msprop:Generator_ChildPropName="GetCustomer_Orders_ProductsRows" msprop:Generator_ParentPropName="Customer_OrdersRow" msprop:Generator_UserRelationName="Customer_Orders_Customer_Orders_Products" msprop:Generator_RelationVarName="relationCustomer_Orders_Customer_Orders_Products" msprop:Generator_UserParentTable="Customer_Orders" />
      <msdata:Relationship name="Products_Customer_Orders_Products" msdata:parent="Products" msdata:child="Customer_Orders_Products" msdata:parentkey="product_id" msdata:childkey="product_id" msprop:Generator_UserChildTable="Customer_Orders_Products" msprop:Generator_ChildPropName="GetCustomer_Orders_ProductsRows" msprop:Generator_ParentPropName="ProductsRow" msprop:Generator_UserRelationName="Products_Customer_Orders_Products" msprop:Generator_RelationVarName="relationProducts_Customer_Orders_Products" msprop:Generator_UserParentTable="Products" />
      <msdata:Relationship name="Customers_Customers_Payment_Methods" msdata:parent="Customers" msdata:child="Customers_Payment_Methods" msdata:parentkey="customer_id" msdata:childkey="customer_id" msprop:Generator_UserChildTable="Customers_Payment_Methods" msprop:Generator_ChildPropName="GetCustomers_Payment_MethodsRows" msprop:Generator_ParentPropName="CustomersRow" msprop:Generator_UserRelationName="Customers_Customers_Payment_Methods" msprop:Generator_RelationVarName="relationCustomers_Customers_Payment_Methods" msprop:Generator_UserParentTable="Customers" />
      <msdata:Relationship name="Ref_Payment_Methods_Customers_Payment_Methods" msdata:parent="Ref_Payment_Methods" msdata:child="Customers_Payment_Methods" msdata:parentkey="payment_method_code" msdata:childkey="payment_method_code" msprop:Generator_UserChildTable="Customers_Payment_Methods" msprop:Generator_ChildPropName="GetCustomers_Payment_MethodsRows" msprop:Generator_ParentPropName="Ref_Payment_MethodsRow" msprop:Generator_UserRelationName="Ref_Payment_Methods_Customers_Payment_Methods" msprop:Generator_RelationVarName="relationRef_Payment_Methods_Customers_Payment_Methods" msprop:Generator_UserParentTable="Ref_Payment_Methods" />
      <msdata:Relationship name="Ref_Product_Types_Products" msdata:parent="Ref_Product_Types" msdata:child="Products" msdata:parentkey="product_type_code" msdata:childkey="product_type_code" msprop:Generator_UserChildTable="Products" msprop:Generator_ChildPropName="GetProductsRows" msprop:Generator_ParentPropName="Ref_Product_TypesRow" msprop:Generator_UserRelationName="Ref_Product_Types_Products" msprop:Generator_RelationVarName="relationRef_Product_Types_Products" msprop:Generator_UserParentTable="Ref_Product_Types" />
      <msdata:Relationship name="Suppliers_Products" msdata:parent="Suppliers" msdata:child="Products" msdata:parentkey="supplier_code" msdata:childkey="supplier_code" msprop:Generator_UserChildTable="Products" msprop:Generator_ChildPropName="GetProductsRows" msprop:Generator_ParentPropName="SuppliersRow" msprop:Generator_UserRelationName="Suppliers_Products" msprop:Generator_RelationVarName="relationSuppliers_Products" msprop:Generator_UserParentTable="Suppliers" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>